20620 REL 11: Contract Summary

SOW Report

Contract 20620 REL 11: EXP 198906201 F&W PROGRAM WEB/DATA SERVICES

Basics

Project Number:

1989-062-01

Title:

Annual Work Plan for Columbia Basin Fish and Wildlife Authority (CBFWA)

BPA PM:

Tracy Hauser

Stage:

Closed

Area:

Province	Subbasin	%
Basinwide	-	100.00%

Contract Number:

20620 REL 11

Contract Title:

EXP 198906201 F&W PROGRAM WEB/DATA SERVICES

Contract Continuation:

Previous:	Next:
n/a	20620 REL 17: 1989-062-01 EXP F&W PROGRAM WEB / DATA SERVICES

Contract Status:

History

Contract Description:

This contract covers staff salary, hardware, software, and server hosting costs necessary for the continued production and maintenance of regionally-significant databases and web applications. These include the CSMEP, PNAMP, CBFWA, Within-Year Budget Modifications, and F&W Program Historical websites and databases.

Account Type(s):

Expense

Contract Start Date:

04/01/2007

Contract End Date:

06/30/2008

Current Contract Value:

$166,624

Expenditures:

$166,624

* Expenditures data includes accruals and are based on data through 28-Feb-2025.

BPA CO:

Kristi Van Leuven (Inactive)

BPA COR:

Alicia Mendenhall (Inactive)

Env. Compliance Lead:

None

Contract Contractor:

Columbia Basin Fish and Wildlife Foundation - COLBASFI00

Work Order Task(s):

WO: 00032640, Task: 1

Contract Type:

Release

Pricing Method:

Cost Reimbursement (CNF)

Road Aerial Hybrid

Photo Locations

300 km

200 mi

Click the map to see this Contract's location details.

Photos

No photos have been uploaded yet for this Contract.

Contract Contacts

Full Name	Organization	Write Permission	Contact Role	Email	Work Phone
Jann Eckman	Columbia Basin Fish and Wildlife Foundation	No	Interested Party	jann.eckman@cbfwa.org	(503) 229-0191
Brian Lipscomb	Columbia Basin Fish and Wildlife Foundation	No	Supervisor	brian.lipscomb@cbfwa.org	(503) 229-0191
Peter Lofy	Bonneville Power Administration	Yes	F&W Approver	ptlofy@bpa.gov	(503) 230-4193
Alicia Mendenhall	Bonneville Power Administration	Yes	COR	aamendenhall@bpa.gov	(503) 230-3774
Molly Moreland	Bonneville Power Administration	Yes		mrmoreland@bpa.gov	(503) 230-3501
Kathie Titzler	Columbia Basin Fish and Wildlife Foundation	Yes	Contract Manager	kathie.titzler@cbfwa.org	(503) 229-0191
Kristi Van Leuven	Bonneville Power Administration	Yes	Contracting Officer	kjvleuven@bpa.gov	(503) 230-3605

Statement Of Work (SOW)

Viewing 8 of 8 Work Statement Elements


Sort Order	WSEV ID	WE ID	Work Element Name	Title	Description	WSE Effective Budget	% of Total WSE Effective Budget	WSE Start	WSE End


A	39750	185	Produce CBFish Status Report	Periodic Status Reports for BPA	The Contractor shall report on the status of milestones and deliverables in Pisces. Reports shall be completed either monthly or quarterly as determined by the BPA COTR. Additionally, when indicating a deliverable milestone as COMPLETE, the contractor shall provide metrics and the final location (latitude and longitude) prior to submitting the report to the BPA COTR.	$1,000	0.59%	07/01/2007	06/30/2008
B	39751	160	Create/Manage/Maintain Database	Manage and Maintain CSMEP database and website	House the CSMEP database and website. Respond to requests for changes to database and website. Troubleshoot any problems.	$50,000	29.41%	04/01/2007	06/30/2008
C	39752	160	Create/Manage/Maintain Database	Manage and Maintain PNAMP database and website	House the PNAMP database and website. Respond to requests for changes to database and website. Troubleshoot any problems.	$5,000	2.94%	04/01/2007	06/30/2008
D	39753	160	Create/Manage/Maintain Database	Maintain and provide access to historical fish and wildlife program information	Maintain historical fish and wildlife project proposal and review data from 1996-2009. Update associated BPA spending data to the Master Data Table to enable long-term analysis of Fish & Wildlife program spending. Maintain and update GIS layer of project locations. Respond to requests for information from the historical database. Collaborate with BPA and NPCC to maintain accessibility of these data. Make data available and searchable on CBFWA website. Associate ongoing regional correspondence with BPA projects to maintain ongoing historical record.	$50,000	29.41%	04/01/2007	06/30/2008
E	39754	161	Disseminate Raw/Summary Data and Results	Create maps, charts, graphs and summaries of data	Upon request, and for the CBFWA website, provide maps, charts and graphs of fish and wildlife program historical data. Provide data for analysis of process and program in within-year modifications database/web application.	$50,000	29.41%	04/01/2007	06/30/2008
F	39755	160	Create/Manage/Maintain Database	Manage and Maintain Within-year Budget Modifications database and website	Maintain database, data, and website for the within-year modifications process. Work with BOG Group to redesign Within-year Modifications website to increase its effectiveness and ease of use. Associate ongoing regional correspondence with within-year requests within database to maintain historical data.	$12,000	7.06%	04/01/2007	06/30/2008
G	39756	119	Manage and Administer Projects	Perform administrative duties associated with this contract	Covers all aspects of CBFWF administration of this web/data services contract.	$2,000	1.18%	08/20/2007	04/30/2008
H	39758	132	Produce Progress (Annual) Report	Submit Progress Report for the period (MMM YYYY) to (MMM YYYY)	No Annual Progress Report is required for this contract. This is a service-based contract: BPA pays for the ongoing web/data services that CBFWA provides, rather than specific accomplishments.	$0	0.00%


						$170,000

Deliverable Status

Deliverable Title	WSE Sort Letter, Number, Title	End	Concluded
Manage and maintain CSMEP database and website	B: 160. Manage and Maintain CSMEP database and website	06/30/2008	06/30/2008
Manage and maintain PNAMP database and website	C: 160. Manage and Maintain PNAMP database and website	06/30/2008	06/30/2008
Manage and maintain historical F&W Program database and website	D: 160. Maintain and provide access to historical fish and wildlife program information	06/30/2008	06/30/2008
CBFWA website	E: 161. Create maps, charts, graphs and summaries of data	06/30/2008	06/30/2008
Manage, redesign and maintain Budget Mods database and website	F: 160. Manage and Maintain Within-year Budget Modifications database and website	06/30/2008	06/30/2008
Funding Package - Submit draft to COTR	G: 119. Perform administrative duties associated with this contract	04/30/2008	04/30/2008

Viewing of Implementation Metrics


Sort Order	WE ID	Work Element Name	Title	Description	Metric ID	Metric	End Fiscal Year	Planned	Actual	Contractor Comments	All Measures	Annual Progress Report Measures	Populations

Viewing of Environmental Metrics Customize


WSE ID	WSE Start	WSE End	WE ID	Title	WSE Progress	Study Plan	Protocol	Category	Subcategory	Focus 1	Focus 2	Specific Metric Title

Focal Species

Primary Focal Species	Work Statement Elements
All Anadromous Salmonids	1 instance of WE 161 Disseminate Raw/Summary Data and Results
Wildlife	1 instance of WE 161 Disseminate Raw/Summary Data and Results

Environmental Compliance

Sort	WE ID	WE Title	Completed
A	185	Periodic Status Reports for BPA	02/09/2007
B	160	Manage and Maintain CSMEP database and website	02/09/2007
C	160	Manage and Maintain PNAMP database and website	02/09/2007
D	160	Maintain and provide access to historical fish and wildlife program information	02/09/2007
E	161	Create maps, charts, graphs and summaries of data	02/09/2007
F	160	Manage and Maintain Within-year Budget Modifications database and website	02/09/2007
G	119	Perform administrative duties associated with this contract	02/09/2007
H	132	Submit Progress Report for the period (MMM YYYY) to (MMM YYYY)	02/09/2007

Reports

SOW Report

Please correct the errors noted below.